package com.sl.au.repository;

import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import com.sl.au.entity.ExdeviPCAssInstructionExcuteWithPlan;

public interface ExdeviPCAssInstructionExcuteWithPlanRepository extends JpaRepository<ExdeviPCAssInstructionExcuteWithPlan, String>{
	@Query("select u from ExdeviPCAssInstructionExcuteWithPlan u where u.PCAssInstructionExcutePlanId = ?1 ")
	Page<ExdeviPCAssInstructionExcuteWithPlan> getList(String key,Pageable pageable);
	
	
	@Query("select count(u) from ExdeviPCAssInstructionExcuteWithPlan u where u.PCAssInstructionExcutePlanId =?1 ")
	long getCount(String key);
}
